FaStudentAid

Logical Entity Name | FaStudentAid
Default Table Name | FaStudentAid
Physical Only | NO
Owner | dbo
Definition |
Note |

FaStudentAid Columns

ColumnName | Domain | Datatype | NULL | Definition
FaStudentAidId |  | int | NO |
SyStudentID |  | int | NO |
AdEnrollID |  | int | NO |
SyAddressID |  | int | NO |
Source |  | char(1) | YES |
FaFundSourceID |  | int | YES |
AwardYear |  | char(7) | YES |
AmAgencyBranchID |  | int | YES |
FaBankID |  | int | YES |
FaServicerID |  | int | YES |
FaGuarantorID |  | int | YES |
AmountPackaged |  | money | NO |
BankFee |  | money | NO |
AmountDisbursed |  | money | NO |
AmountCanceled |  | money | NO |
AmountRefunded |  | money | NO |
DateLoanStart |  | datetime | YES |
DateLoanEnd |  | datetime | YES |
DateAppSent |  | datetime | YES |
DateAppReceived |  | datetime | YES |
FaStudentAYID |  | int | YES |
FirstPayDate |  | datetime | YES |
LastInterestDate |  | datetime | YES |
PaymentDay |  | tinyint | YES |
PaymentFreq |  | smallint | YES |
InterestRate |  | numeric(5, 2) | YES |
NumberPayments |  | smallint | YES |
TotalPaid |  | money | YES |
PrincipalBalance |  | money | YES |
InterestBalance |  | money | YES |
NextPayDate |  | datetime | YES |
PaymentAmount |  | money | YES |
Status |  | char(1) | YES |
Comment |  | text | YES |
UserID |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |
FaStudentPellID |  | int | YES |
BankFeeToCOA |  | bit | NO |
InterestRebateAmt |  | numeric(18, 0) | YES |
ServicerRecordID |  | char(20) | YES |
AddUserID |  | int | NO |
FaBatchPackageID |  | int | YES |
EstimatedAward |  | bit | NO |
SecondaryInterestRate |  | numeric(6, 3) | YES |
SecondaryInterestRateEffDate |  | datetime | YES |
IntOnlyUntilDate |  | datetime | YES |
AccruedInterestAmt |  | money | NO |
IsAutoDraft |  | bit | NO |
EffectiveDate |  | datetime | YES |
SaStudentBankAccountID |  | int | YES |
SaCcId |  | int | YES |
IsAutoCredit |  | bit | NO |
CcEffectiveDate |  | datetime | YES |
T4BalanceEvaluated |  | bit | NO |
LastStatementPrintDate |  | datetime | YES |
LastPNPrintDate |  | datetime | YES |
FaCODGrantID |  | int | YES |
UserLocked |  | bit | NO |
LockedByUserId |  | int | YES |
DownPayment |  | money | YES |
PromNoteCmDocumentId |  | int | YES |
CalculationDate |  | datetime | YES |
LoanIdentificationNumber |  | int | YES |
IsReAllocated |  | bit | NO |
Rep9010DiscountRate |  | numeric(5, 2) | YES |
Rep9010CollectionRate |  | numeric(5, 2) | YES |
Rep9010NumOfYears |  | smallmoney | YES |
FaStudentLoanPeriodID |  | int | YES |
LoanAcYrStartDate |  | datetime | YES |
LoanAcYrEndDate |  | datetime | YES |
IsAXLinkedFWS |  | bit | NO |

FaStudentAid Primary and Unique Keys

Key Name | Key Type | Keys
FaStudentAid_FaCODGrantID_FaStudentAidID_U_N_IDX | Index | FaCODGrantID, FaStudentAidId
FaStudentAid_SyStudentID_AwardYear_FaFundSourceID_FaStudentAidID_U_N_IDX | Index | SyStudentID, AwardYear, FaFundSourceID, FaStudentAidId
FaStudentAid_AwardYear_FaStudentAidID_U_N_IDX | Index | AwardYear, FaStudentAidId
FaStudentAid_FaStudentAidID_U_C_IDX | PrimaryKey | FaStudentAidId
Uk_FaStudentAid_FaFundSourceID_AwardYear_Status_AdEnrollID_FaStudentPellID_SyStudentID_FaStudentAidID | Index | FaFundSourceID, AwardYear, Status, AdEnrollID, FaStudentPellID, SyStudentID, FaStudentAidId

FaStudentAid Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
FaLender | Non-Identifying | Zero or One to Zero or More | FK_FaStudentAid_FaBankID_FaLender_FaLenderID |  |  | FaBankID | NO | YES
FaBatchPackage | Non-Identifying | Zero or One to Zero or More | FK_FaStudentAid_FaBatchPackageID_FaBatchPackage_FaBatchPackageID |  |  | FaBatchPackageID | NO | YES
FaCODGrant | Non-Identifying | Zero or One to Zero or More | FK_FaStudentAid_FaCODGrantID_FaCODGrant_FaCODGrantID |  |  | FaCODGrantID | NO | YES
FaFundSource | Non-Identifying | Zero or One to Zero or More | FK_FaStudentAid_FaFundSourceID_FaFundSource_faFundSourceID |  |  | FaFundSourceID | NO | YES
FaStudentPell | Identifying | One To Zero or More | FK_FaStudentAid_FaStudentAidID_FaStudentPell_FaStudentPellID |  |  | FaStudentAidId | NO | YES
FaStudentAY | Non-Identifying | Zero or One to Zero or More | FK_FaStudentAid_FaStudentAYID_FaStudentAY_FAStudentAYID |  |  | FaStudentAYID | NO | YES
SaCC | Non-Identifying | Zero or One to Zero or More | FK_FaStudentAid_SaCcId_SaCc_SaCcId |  |  | SaCcId | NO | YES
SaStudentBankAccount | Non-Identifying | Zero or One to Zero or More | FK_FaStudentAid_SaStudentBankAccountID_SaStudentBankAccount_SaStudentBankAccountID |  |  | SaStudentBankAccountID | NO | YES
syStudent | Non-Identifying | One To Zero or More | FK_FaStudentAid_SyStudentID_syStudent_SyStudentID |  |  | SyStudentID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
FaCampusVantageWorkStudyPayroll | Non-Identifying | One To Zero or More | FK_FaCampusVantageWorkStudyPayroll_FaStudentAidID_FaStudentAid_FaStudentAidId |  |  |  | NO | YES
FaCashPlanWorkflowAudit | Non-Identifying | One To Zero or More | FK_FaCashPlanWorkflowAuditFaStudentAidId_FaStudentAidFaStudentAidId |  |  |  | NO | YES
FaCODGrantDisb | Non-Identifying | One To Zero or More | FK_FaCODGrantDisb_FaCODGrantID_FaStudentAid_FaStudentAidID |  |  |  | NO | YES
FaDisb | Non-Identifying | One To Zero or More | FK_FaDisb_FaStudentAidID_FaStudentAid_FaStudentAidID |  |  |  | NO | YES
FaLoan | Non-Identifying | One To Zero or More | FK_FaLoan_fastudentaidid_FaStudentAid_FaStudentAidID |  |  |  | NO | YES
FaLoanCommonLineChangeSendLog | Non-Identifying | One To Zero or More | FK_FaLoanCLChangeSendLog_FaStudentAidId_FaStudentAid_FaStudentAidId |  |  |  | NO | YES
FaPromNotePrintAssignment | Non-Identifying | One To Zero or More | FK_FaPromNotePrintAssignmentFaStudentAidId_FaStudentAidFaStudentAidId |  |  |  | NO | YES
FaRefund | Non-Identifying | One To Zero or More | FK_FaRefund_FaStudentAidID_FaStudentAid_FaStudentAidID |  |  |  | NO | YES
FaStudentAidCalculation | Non-Identifying | One To Zero or More | FK_FaStudentAidCalculationFaStudentAidID_FaStudentAidFaStudentAidID |  |  |  | NO | YES
FaStudentAidCashPlanAssignment | Non-Identifying | One To Zero or More | FK_FaStudentAidCashPlanAssignment_CashFaStudentAidId_FaStudentAid_FaStudentAidId |  |  |  | NO | YES
FaStudentAidCashPlanHistory | Non-Identifying | One To Zero or More | FK_FaStudentAidCashPlanHistory_FaStudentAid_FaStudentAidId |  |  |  | NO | YES
FaStudentAidCalculation | Non-Identifying | One To Zero or More | FK_FaStudentAidID |  |  |  | NO | YES
FaStudentAYPaymentPeriod | Non-Identifying | One To Zero or More | FK_FaStudentAYPaymentPeriod_FaStudentAidId_FaStudentAid_FaStudentAidId |  |  |  | NO | YES
FaStudentLPPaymentPeriod | Non-Identifying | One To Zero or More | FK_FaStudentLPPaymentPeriod_FAStudentAid_FAStudentAidID |  |  |  | NO | YES
SaCollections | Non-Identifying | One To Zero or More | FK_SaCollections_FaStudentAidID_FaStudentAid_FaStudentAidID |  |  |  | NO | YES
SaStatementHistory | Non-Identifying | One To Zero or More | FK_SaStatementHistory_FaStudentAidID_FaStudentAid_FaStudentAidID |  |  |  | NO | YES
SyAudit_FaStudentAid | Non-Identifying | One To Zero or More | FK_SyAudit_FaStudentAid_RecordID_FaStudentAid_FaStudentAidID |  |  |  | NO | YES
SyServiceMessageSourceRecord | Non-Identifying | One To Zero or More | FK_SyServiceMessageSourceRecordFaStudentAidId_FaStudentAidFaStudentAidId |  |  |  | NO | YES

FaStudentAid Check Constraints

Check Constraint Name | CheckConstraint
Chk_FaStudentAid_IntOnlyUntilDate | ([IntOnlyUntilDate] is null and [FirstPayDate] is null or [IntOnlyUntilDate] is null and [FirstPayDate] is not null or [IntOnlyUntilDate] is not null and [FirstPayDate] is not null and [IntOnlyUntilDate] > [FirstPayDate])
Chk_FaStudentAid_SecondaryInterestRateEffDate | ([SecondaryInterestRateEffDate] is null and [FirstPayDate] is null or [SecondaryInterestRateEffDate] is null and [FirstPayDate] is not null or [SecondaryInterestRateEffDate] is not null and [FirstPayDate] is not null and [SecondaryInterestRateEffDate] > [FirstPayDate])

FaStudentAid Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group | PRIMARY

FaStudentAid Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentAward | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaStudentAid | NO |  |  |

FaStudentAid Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | LedgerCard_Billing
Logical | RefundCalculation
Logical | Refunds_Stipends
Logical | StudentPayments_Collections
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaStudentAid Data Movement Rules

Name | Type | Rule Text/Value